create table jms_dim.dim_yl_mix_package_config_dt
(
     id                     string
    ,proxy_code             string     comment  '代理区编码'
    ,proxy_name             string     comment  '代理区名称'
    ,apply_center_code      string     comment  '申请中心编码'
    ,apply_center_name      string     comment  '申请中心名称'
    ,des_center_code        string     comment  '目的中心编码'
    ,des_center_name        string     comment  '目的中心名称'
    ,mix_package_flow       string     comment  '混建包流向'
    ,mix_package_first_code string     comment  '混建包一段码'
    ,apply_reason           string     comment  '申请原因'
    ,audit_code             string     comment  '审核人编码'
    ,audit_status           int        comment  '0待审核 1 审核通过 2 审核拒绝  3 作废'
    ,audit_id               int        comment  '审核人id'
    ,audit_name             string     comment  '审核人名称'
    ,mix_package_name       string     comment  '混建包名称'
    ,mix_package_code       string     comment  '混建包编码'
    ,remark                 string     comment  '备注'
    ,create_time            string     comment  '创建时间'
    ,create_by_id           int        comment  '创建id'
    ,create_by_code         string     comment  '创建人code'
    ,create_by_name         string     comment  '创建人name'
    ,audit_time             string     comment  ''
)comment '混建包'
PARTITIONED BY(
`dt` string COMMENT'时间分区(yyyy-MM-dd)')
stored as parquet
LOCATION
'/dw/hive/jms_dim.db/external/dim_yl_mix_package_config_dt'
TBLPROPERTIES(
'parquet.column.index.access'='true'
);